1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
| #!/bin/bash
n_date=`date -d '1 day ago' +%Y-%m-%d`
log_date=`date -d '1 day ago' +%Y%m%d`
echo $n_date
echo $log_date
source /etc/profile
db_mmbapi="mysql -u85fF526c22E69b -pK08e7b95d3253a6 -h192.168.1.72 -Dmmbapi -Bs"
db_nn_monitor="mysql -u85fF526c22E69b -pK08e7b95d3253a6 -h192.168.1.69 -Dnn_monitor -Bs"
db_lmb_shop="mysql -u85fF526c22E69b -pK08e7b95d3253a6 -h192.168.1.75 -Dlmb_shop -Bs"
db_lmb_oss="mysql -uV4cdef5c4dbf -pf45c2Cb35cb95d -h192.168.1.69 -Dlmb_oss -Bs"
db_lmb_user_behavior="mysql -u85fF526c22E69b -pK08e7b95d3253a6 -h192.168.1.69 -Dlmb_user_behavior -Bs"
db_lmb_user="mysql -u85fF526c22E69b -pK08e7b95d3253a6 -h192.168.1.72 -Dlmb_user -Bs"
db_lmb_preg="mysql -u85fF526c22E69b -pK08e7b95d3253a6 -h192.168.1.77 -Dlmb_preg -Bs"
db_lmb_admin="mysql -u85fF526c22E69b -pK08e7b95d3253a6 -h192.168.1.79 -Dlmb_admin -Bs"
db_lmb_lotus="mysql -ulmb_user -pfjldurioejklfduire -P3307 -h192.168.1.67 -Dlmb_lotus -Bs"
db_lmb_third="mysql -u85fF526c22E69b -pK08e7b95d3253a6 -h192.168.1.77 -Dlmb_third -Bs"
db_lmb_admin="mysql -u85fF526c22E69b -pK08e7b95d3253a6 -h192.168.1.69 -Dlmb_admin -Bs"
LASTLINE=`date +"%Y-%m-%d %H:%M:%S"`
getmerge_log()
{
for i in `cat '/home/log_data/scripts/info/getmerge_log.data'`
do
cat /log/d/blog/robot/robot_request/$i".log" | awk 'BEGIN { OFS = " " } {print $2}' >> /home/log_data/scripts/robot/getmerge_log.log
CURTIME=`date +"%Y-%m-%d %H:%M:%S"`
Sys_data=`date -d "$CURTIME" +%s`
In_data=`date -d "$LASTLINE" +%s`
interval=`expr $Sys_data - $In_data`
echo $interval" s"
done
}
getmerge_log
|
